package com.ncloud.billing.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.ncloud.billing.entity.BsProduct;



@Mapper
public interface BsProductMapper {
	
	@Select(value = {"SELECT prod_inst_id, cust_id, prod_id, prod_name, begin_date, end_date, update_time, update_user, remark FROM bs_product "
			+ "where cust_id = #{cust_id} "})
	@Results({ @Result(column = "prod_inst_id", property = "prod_inst_id"), @Result(column = "cust_id", property = "cust_id"),
         @Result(column = "prod_id", property = "prod_id"),@Result(column = "prod_name", property = "prod_name"),
         @Result(column="begin_date",property="begin_date"),@Result(column="end_date",property="end_date"),
         @Result(column="update_time",property="update_time"),@Result(column="update_user",property="update_user"),
         @Result(column="remark",property="remark")})
	public List<BsProduct> getBsProductByCustID(Long cust_id);
} 